System, method and apparatus for consolidating and searching educational opportunities

ABSTRACT

An application for a method and system providing educational seekers a search tool that finds education opportunities across a large number of educational/training providers. The search tool finds courses and/or programs of interest such as certifications, vocational programs, two-year programs, four-year programs, MBA programs, certain financial aide features, specific course offerings, specific sports programs, placement success, etc, The system includes educational software robots called edu bots that visit educational program hosting web sites of the various educational/training providers, extracting information regarding the programs, courses, faculty, financial assistance, sports programs, location, extra-curricular activities, etc. The information is then stored in a common, searchable database for later searching by the educational seeker.

CROSS REFERENCES TO RELATED APPLICATIONS

This utility patent application is a continuation-in-part of commonlyowned U.S. patent application Ser. No. 11/393,394 filed on Mar. 30, 2006entitled: “System, method and computer program products for creating andmaintaining a consolidated jobs database” this Utility patentapplication incorporated by reference herein.

FIELD

This invention relates to the field of searching and more particularlyto a system, method and apparatus for finding educational programdescriptions on a wide area network and importing the descriptions intoa central searchable database.

BACKGROUND

Many people, for instance, those about to graduate high school, arelooking for educational programs. In the distant past, guidancecounselor offices contained countless brochures from variousinstitutions such as colleges, universities, trade schools, etc. Withthe wide-spread availability of the Internet (World Wide Web), the arthas migrated to an online set of catalogs. In such, each school orinstitution (educational/training provider) has a web site and, onefeature of that web site is descriptions of programs, tracts, degreeprograms, classes, etc. This is a vast improvement over paper catalogs,but neither provides a robust approach to finding the right program forthe educational seeker.

There are several weaknesses in the current approach of finding aneducational program. First, the educational seeker, looking for acertain type of program, doesn't necessarily know whicheducational/training provider offer such a program. For example, if aeducational seeker from California is interested in studying law tobecome an attorney, they don't necessarily know about a small privateschool in the Tampa Bay area of Florida and, therefore, are not prone tovisit that educational/training provider's web site to check out thepossible class work. Secondly, each educational/training provider's website is structured differently making it more difficult for theeducational seeker to locate the programs once they find theeducational/training provider's web site. Some educational/trainingproviders organize by subject, some by degree, etc. There is nonormalized hierarchy and/or format for such web sites, making it tediousto navigate through them to find the right program for the educationalseeker.

Thirdly, there is no way to find programs based upon specific criterion.For example, if a educational seeker wants to attend a school that has adegree program leading to a master's degree in biology and also wants tohave a minor degree in music, the educational seeker must visit manyeducational/training provider web sites to see if they offer each,having no way to search for all educational/training providers thatoffer both together. Another example is a educational seeker who desiresa degree in chemistry with a minor in music and wants to study in thePacific Northwest. Again, current technology does not permit such asearch.

Additionally, the educational seeker needs to compare one institution toanother. Upon finding a few institutions in the Pacific Northwest thatoffer a degree in chemistry with a minor in music, the educationalseeker often needs to compare class schedules, degree requirements,entry requirements, scholarships available, credit hours required,required courses, elective courses available, cost per credit hour,housing, etc. Currently, no single system provides consolidated data formultiple educational/training providers.

Often it is difficult for the educational seeker to determine from aneducational/training provider's web site, which location is the parentcampus as opposed to a smaller, satellite campus; details on the offeredprograms; and availability of courses, etc. To get such information, theeducational seeker often needs to request a brochure/catalog or call theschool.

Prior advances have not addressed a consolidated, searchable database ofcourse and/or program description information. US Pat. Pub. No.2007/0122791 to Sperle describes a method of updating course catalogs,but does not access a multitude of educational/training providerdatabases to develop a database of course and/or program information. USPat. Pub. No. 2008/0270166 describes a method of transferring aeducational seeker's transcript over the web, but does not access amultitude of educational/training provider databases to develop adatabase of course and/or program information.

In addition, governments are charged with the task of reducingunemployment. To this end, it is desired to have a system that, coupledwith an workforce management application, identifies positions availablein a certain area and, when a limited number of such positions areavailable, the system suggests related positions and, if additionaltraining is needed to file those positions, presents local courses forthe individual to train in the area of the positions that are in higherdemand. No such system is currently available. For example, if ajobseeker is trying to find a position as a certified networkadministrator and there are few or no positions that match that criteriain the area of the jobseeker but there are related positions such as WebDevelopment, but the jobseeker lacks a skill generally needed for WebDevelopment (e.g. C++ programming), a desired feature of a system willidentify the positions available and the needed course and provide alist of courses that the jobseeker can take to prepare and apply for theWeb Development positions.

In another example, a job seeker has skills to be an administrativeassistant, but a search of open positions finds very few. The searchfinds several positions as a paralegal, but the job seeker lackstraining to be a paralegal, but in the prior art, the system did notpresent a list of paralegal training programs provided in the locale ofthe jobseeker that, if completed, qualified the jobseeker for the openpositions as a paralegal.

Systems that “spider” the Internet for job postings are known. Forexample, U.S. patent application Ser. No. 11/393,394, filed on Mar. 30,2006, titled, “SYSTEM, METHOD AND COMPUTER PROGRAM PRODUCTS FOR CREATINGAND MAINTAINING A CONSOLIDATED JOBS DATABASE” describes a system forspidering job postings from various web sited containing job postingsand storing the job postings in a searchable database. This patentapplication is here within included by reference.

What is needed is a system that will identify educational programopportunities, consolidate the individual opportunities into a centrallocation and provide advanced searching capabilities to the educationalseeker for finding educational opportunities that match the educationalseeker's needs and desires.

SUMMARY OF THE INVENTION

A method and system for prospective educational seekers to seek outeducation opportunities across a large number of educational/trainingproviders to find courses and/or programs of interest such as training,certifications, two-year programs, four-year programs, MBA programs,certain financial aide features, specific course offerings, specificsports programs, placement success, etc. The system uses educationalsoftware robots, edu bots, to visit web sites of the variouseducational/training providers (schools, institutions, etc), extractinginformation regarding the programs, courses, faculty, financialassistance, sports programs, location, extra-curricular activities, etc.The information is then stored in a common, searchable database forlater searching by the educational seeker.

In one embodiment, a system for creating and updating educationalprogram and course information in a searchable database is disclosed.The system includes a computer connected to a network with a storagedevice operationally interfaced to the computer. A searchable databaseis stored within the storage device. The system includes a plurality ofedu bots. Each of the edu bots is independently programmed by aprogrammer to visit an assigned educational program and courseinformation hosting site through the network. Each of the edu bots isindependently programmed by the programmer to extract educationalprogram and course information from the visited educational program andcourse information hosting site. Each of the edu bots is independentlyprogrammed by the programmer to update the searchable database with theeducational program and course information. The system includes adispatcher running on the computer. The dispatcher periodically runs theplurality of edu bots. Each edu bot is customized for each particulareducational program and course information hosting site.

In another embodiment, a method for creating and updating a consolidateddatabase of educational programs and courses is disclosed. The methodincludes the steps of manually identifying a set of educational programsand courses hosting sites and for each site within the set: manuallyprogramming and testing an edu bot specific to the each site by aprogrammer. The edu bot is programmed to visit said each site and toextract educational program and course information from said each siteand to store the educational program and course information in asearchable database. The method includes running the edu bot to visitsaid each site and extract the educational program and courseinformation into the searchable database and periodically running theedu bots to update the searchable database.

In another embodiment, computer readable storage medium includingcomputer programming instructions that cause a computer to perform themethod for creating and updating a consolidated database of educationalprogram and course information is disclosed. The method includes thesteps of accepting a list of educational program and course informationhosting sites having educational program and course information thereinthen, for each site within the list of educational program and courseinformation hosting sites: creating an edu bot programmed to visit saideach site and programmed to extract educational program and courseinformation stored at said each site and the edu bot programmed to storethe educational program and course information in a searchable database;running the edu bot to visit said each site and to extract theeducational program and course information and to store the educationalprogram and course information in the searchable database; andperiodically running the edu bots to update the searchable database.Each of the computer programming instructions comprising each of the edubots is programmed independently by a software developer based upon saideach site.

In another embodiment, a computer program product used with a computersystem in creating and updating a consolidated database of educationalprogram and course information is disclosed including a plurality ofidentified educational program and course information hosting sites anda computer usable medium having computer-readable code means embodied inthe medium. The computer-readable code means includes a plurality of edubots. Each edu bot has a plurality of computer usable code forextracting educational program and course information from a respectiveeducational program and course information host site of the plurality ofidentified educational program and course information hosting sites.Each edu bot also has a plurality of computer readable code for updatinga searchable database with the educational program and courseinformation. Each of the computer readable code is written independentlyby a programmer and customized for each of the plurality of identifiededucational program and course information hosting sites.

BRIEF DESCRIPTION OF THE DRAWINGS

The invention can be best understood by those having ordinary skill inthe art by reference to the following detailed description whenconsidered in conjunction with the accompanying drawings in which:

FIG. 1 illustrates a schematic view of a system of a first embodiment.

FIG. 2 illustrates a first flow chart of a system for retrievingeducational programs from disparate web sites.

FIG. 3 illustrates a second flow chart of a system for retrievingeducational programs from disparate web sites.

FIG. 4 illustrates a second flow chart of a system for retrievingeducational programs from disparate web sites.

FIG. 5 illustrates plan view of a typical computer system used forclients and/or servers.

FIG. 5A illustrates plan view of a typical multi-server computer systemused for retrieving educational programs and searching the retrieveddata.

FIG. 6 illustrates a first typical educational program web page of theprior/current art.

FIG. 7 illustrates a first typical educational program web page of theprior/current art.

FIG. 8 illustrates a first typical user interface for retrievingeducational programs.

FIG. 9 illustrates a second typical user interface for retrievingeducational programs.

FIG. 10 illustrates a typical response user interface for displayingeducational programs.

FIG. 11 illustrates a completed typical user interface for retrievingeducational courses.

FIG. 12 illustrates a typical response user interface for displayingeducational programs.

FIG. 13 illustrates a course display user interface for retrievingeducational programs.

FIG. 14 illustrates an exemplary schema of a database used forretrieving educational programs.

FIG. 15 illustrates a schematic view of a system of a second embodiment.

DETAILED DESCRIPTION

Reference will now be made in detail to the presently preferredembodiments, examples of which are illustrated in the accompanyingdrawings. Throughout the following detailed description, the samereference numerals refer to the same elements in all figures. Thisdisclosure relates to all types of educational/training providersincluding, but not limited to, training schools, certification schools,universities, colleges, technical institutes, learning centers, trafficschools, driver education schools, etc.

Referring to FIG. 1, a schematic view of a system of a first embodimentis shown. Educational/training providers host web sites that describetheir educational programs. One or more Edu bots 20 periodically visitthese educational program hosting sites 12/14/16 to extract educationalprogram offering information. The educational program hosting sites12/14/16 are, for example, state university admission posting web sitessuch as the University of Southern Florida (USF) 12 and Rutgers 16;private education web sites such as Devry 14 and any known web sitecontaining educational program information. This includes sites in theUSA as well as outside of the USA.

An Edu bot 20 is, for example, a software module that is programmed tovisit a web site that contains descriptions of one or more educationalprograms or offerings, extracts the descriptions and, if needed,normalized the descriptions for storage in the searchable database 22.It is anticipated that, for some web sites, multiple Edu bots 20 areused due to differences between descriptions of different educationalopportunities, for example, when different departments within aUniversity use different formats for their educational programdescriptions. It is also anticipated that, for some web sites, a singleEdu bot 20 is programmed to extract educational descriptions frommultiple web sites being that those web sites share, for example, acommon format. In one embodiment, the Edu bots 20 are written by aperson (programmer) given the target web site(s) and tested beforecontributing to a live, searchable database 22. In some embodiments, theEdu bots 20 are generated or partially generated by software, thencompleted and tested before contributing to a live, searchable database22.

A list of the target educational/training provider sites is created by aperson searching the network for such sites. For each particular hostingsite such as sites 12/14/16, there is one or more corresponding edu bot20 designed/programmed to find educational program content, parseinformation from the educational program content, normalize theinformation and store the information in the searchable educationalcourse information database 22. For much of the information found in theeducational information, the data is copied directly into a record ofthe searchable educational course information database 22. For example,the schema of the searchable educational course information database 22has a field for prerequisites and the hosting site has a field for entryrequirements, then that field is copied directly into the searchablerecord for that educational program data record. Alternately, if theeducational program has a field for class meeting schedule (e.g. M/T/F8:00 AM) and the searchable educational course information database 22has a field for course meeting days and another field for course meetingtime, then the field is parsed to place “M/T/F” into the field forcourse meeting days and “8:00 AM” in the field for meeting time by adata conversion routine 21.

The educational seekers (educational seeker) access the searchabledatabase 22 through a search engine 24 that presents a search userinterface on the educational seekers' workstation 30 (e.g. personalcomputer, hand-held device, cellular phone, etc). An educational seekeris a person who is interested in finding information about educationalprograms. In the past, the educational seeker needed knowledge aboutvarious educational/training providers such as technical schools,vocational training, colleges, universities, etc., in order to know howto search the Internet for such offerings. By merging many of thepossible course descriptions from many different educational offeringsinto a searchable database 22 and providing search tools, theeducational seeker need only search one searchable database 22 to findofferings from many different educational/training providers.

Similarly, a job seeker is a person who is interested in finding a job.In embodiments in which the searchable database 22 (either the samesearchable database 22 or a different searchable database 22), the jobseeker provides their qualifications and preferences and the searchengine 24 finds all job postings in the searchable database 22 thatmatch these qualifications and preferences. In some embodiments, as willbe discussed, the search engine 24 has knowledge of relationshipsbetween job categories and knowledge of the prerequisites needed for thejob categories and, the search engine 24 expands the search to findsimilar job postings to those matching the job seeker's qualificationsand, using educational data in the searchable database 22, the searchengine 24 presents the expanded results along with educationalrequirements and possible educational programs that the job seeker needtake in order to apply for job positions in the expanded results.

Many different types of searches and output reports are anticipatedranging from a simple search to a very complex search and detailedreport. An example of a simple search is “show me all CNA trainingclasses in Florida.” and an example of a more complex search is “show meall 4-year schools in Florida with majors in Biology and provideentrance requirements.” The former, for example, results in a list ofeducational/training providers. The later, for example, results in alist of educational/training providers along with entry requirements foreach school/curriculum. For example, one educational/training providerrequires a SAT score of 1000 for all students, but then for biologystudents, freshmen are required to take Chemistry I and II and at leasttwo humanities classes, etc. The generated report include any or alldata including the day/time of class meeting, location of classes, labrequirements, credit hours, teacher/professor, cost, cost per credit,pre-requisites, co-requisites, degree requirements, language ofinstruction, course/program goals, financial aid, placement programs,certifications of faculty, degree programs, certifications, etc.

Referring to FIG. 2, a first flow chart of a system for retrievingeducational programs from disparate web site is shown. A list ofeducational program hosting websites is compiled. This is done by aperson searching for websites and looking for at least one educationalprogram and then adding the address (URL) of that educational programhosting sites into a list of educational program hosting sites. Next,one or more programmers generate 40 an edu bot 20 for one of the hostingsites in the list. The programmer uses the location of the educationalprogram postings from the list and a sample of a educational programdescription from that site to create the edu bot 20 for that particularhosting sites. The edu bot 20 is written in any desired programminglanguage, preferably using a scripting language. Once created, the edubot 20 is tested 41 by running it against the target hosting site(s) andif it doesn't find and parse the educational program data from that siteor generates erroneous outputs 42, it is repaired 43 and the previoustwo steps 41/42 are repeated until the edu bot 20 operates correctly.Once running correctly, the edu bot 20 is optionally run 44 to extractthe educational program postings from the target educational site andadd them to the searchable educational program database 22 and the edubot 20 is added 45 to the edu bot batch schedule (schedule of active edubots 23) so it is scheduled to run on a regular basis to extract any neweducational program postings or changed postings from that educationalposting web site.

Referring to FIG. 3, a second flow chart of a system for retrievingeducational programs from disparate web sites is shown. The schedule ofactive edu bots 23 created by the previous step (see FIG. 2) is coupledto a dispatcher 50. The dispatcher periodically goes through theschedule of active edu bots 23 and executes one or more edu bots 20 inorder to update the searchable educational program database 22. In thepreferred embodiment, the dispatcher 50 wakes up during the evening andexecutes all available edu bots 20. Alternately, the dispatcher 50 wakesup at any time based upon the selection of an administrator. In someembodiments, the edu bots 20 are executed sequentially while in otherembodiments, several edu bots 20 are executed concurrently. In someembodiments, several edu bots 20 run on a single server while in otherembodiments, there are multiple servers and one or more edu bots 20 arerun concurrently on each of the servers.

There are many ways known in computer operating systems to schedule adispatcher 50 including the UNIX cron(1) table, and any method workswell in the present invention. When the dispatcher 50 runs, it selectsall or a subset of the active edu bots from the schedule of active edubots 23, selecting the next one from a list 51 and executing it 52,whereby the edu bot 20 updates the searchable educational programdatabase 22 with any new, changed or deleted educational programinformation from the job hosting web site associated with that edu bot20. If there are more active edu bots in the list 53, the previous twosteps 51/52 are repeated until none are left. When the edu bot 20 isexecuted, it spiders its respective educational program hosting web site12/14/16 and updates the searchable educational program database 22 withany changes to existing educational programs or the addition of any neweducational programs found. If a previously extracted educationalprogram is no longer present on that web site 12/14/16 for a period oftime, it is marked as “no-longer-offered” or it is removed from thesearchable educational program database 22. This time period allows theeducational program to remain in the searchable educational programdatabase 22 even if it cannot be found at the hosting site. The entry inthe educational program database 22 remains, at least for a period oftime, in case the hosting site is unavailable for maintenance, etc.

Referring to FIG. 4, a second flow chart of a system for retrievingeducational programs from disparate web sites is shown. The task ofgenerating an edu bot 20 for a target educational program hosting sites60 includes (in any order) adding the location of the target educationalprogram hosting sites 61 to the edu bot 20, adding extractionspecification scripts 62 for the target web site 12/14/16 to the edu bot20 and adding data conversion scripts for the target web site 63 to theedu bot 20. The location of the target educational program hosting sites61 include, for example, the home page where the edu bot starts to“walk,” the home page to find active educational program descriptionsor, in some embodiments, one or more individual sub-pages, eachcontaining one or more pointers to educational programs hosted on theweb site. The extraction scripts include information leading to thelocation of each field within the educational descriptions on thehosting sites and can be an absolute field location (e.g., row andcolumn) or a field title string (e.g., “Name:”) or any other means forfinding a specific field. The edu bot is be written in any desiredprogramming language, preferably a scripting language.

Referring to FIG. 5 and FIG. 5 a, a schematic block diagram of anexemplary computer system of the present invention is shown. Althoughshown in its simplest form, having a single processor, many differentcomputer architectures are known that accomplish similar results in asimilar fashion and the present invention is not limited in any way toany particular computer system. The present invention works wellutilizing a single processor system as shown in FIG. 5, a multipleprocessor system where multiple processors share resources such asmemory and storage, a multiple server system (as in FIG. 5 a) whereseveral independent servers operate in parallel and have a copy orshared access to the searchable educational program database 22 or anycombination.

In this sample architecture, a processor 210 is provided to executestored programs that are generally stored for execution within a memory220. The processor 210 can be any processor or a group of processors,for example an Intel Pentium-4® CPU or the like. The memory 220 isconnected to the processor and can be any memory suitable for connectionwith the selected processor 210, such as SRAM, DRAM, SDRAM, RDRAM, DDR,DDR-2, etc. Firmware is stored in firmware storage 225 that is connectedto the processor 210 and may include initialization software known asBIOS. This initialization software usually operates when power isapplied to the system or when the system is reset.

Also connected to the processor 210 is a system bus 230 for connectingto peripheral subsystems such as a network interface 280, a hard disk240, a CDROM 250, a graphics adapter 260 and a keyboard/mouse 270. Thegraphics adapter 260 receives commands and display information from thesystem bus 230 and generates a display image that is displayed on thedisplay 265.

In general, the hard disk 240 may be used to store programs, executablecode and data persistently, while the CDROM 250 may be used to load saidprograms, executable code and data from removable media onto the harddisk 240. These peripherals are meant to be examples of input/outputdevices, persistent storage and removable media storage. Other examplesof persistent storage include core memory, FRAM, flash memory, etc.Other examples of removable media storage include CDRW, DVD, DVDwriteable, compact flash, other removable flash media, floppy disk,ZIP®, laser disk, etc. In some embodiments, other devices are connectedto the system through the system bus 230 or with other input-outputconnections. Examples of these devices include printers; mice; graphicstablets; joysticks; and communications adapters such as modems andEthernet adapters.

The network interface 280 connects the computer-based system to theworld-wide-web 10, preferably, through a high speed link such as a cablebroadband connection, a Digital Subscriber Loop (DSL) broadbandconnection, a T1 line or a T3 line.

FIG. 5 a shows a set of servers 290, each having access to thesearchable educational program database 22. In this example, edu bots 20are preferably run in parallel on each server 290, accessing theeducational program hosting sites through, in this example, a serial T1line operating at 1.44 Mbps providing access to the world-wide-web (www)or any known broadband connection including, but not limited to cable,fiber, copper, DSL and T3, etc.

Referring to FIG. 6, a first typical educational program web page 70 ofthe prior/current art is shown. This is a typical high-level degree webpage that a person seeking such an educational opportunity sees bydirectly accessing a hosting web site 12/14/16. Unfortunately, to findsuch a page using the prior art, a seeker needs to know that a certaineducational/training provider offers this program, then must find themain web site for that institution, then must navigate that web site tofind information related to their educational need. Finding a complete,or almost complete, set of courses available for a certain criteria isalmost impossible utilizing the prior art without undo searching.Trained educational program searchers know what to look for and how tofind such programs, while the novice often misses importantopportunities because some sites use different keywords and/ordescription nomenclature.

The edu bots 20 are programmed to visit the educational program hostingsite 70 and extract the information from such a web page 70 and placethe extracted information in a record within the searchable educationprogram database 22. For this exemplary web page 70, the educationalinstitution 72 is extracted and placed in a record. From the page 70content, it is determined that the page 70 is a description of a degreeprogram (e.g. BA in Computer Science 74) and the record is markedaccordingly (e.g. 4-year degree, bachelors). Degree requirements such asminimum GPA required to maintain the program 76 are extracted,normalized and placed in the record. For example, the required GPA 78(2.35) is captured and placed in the record. If found, a list ofprerequisites 80 is extracted and placed in the record. Since records ofthe prerequisite courses are also stored in the searchable educationalprogram database 22, links and/or pointers to the prerequisites arestored in the record for fast access to these courses. If found, a listof required courses 82 are extracted and placed in the record. Again,since images of the prerequisite courses are also stored in thesearchable educational program database 22, links and/or pointers to theprerequisites are stored in the record for fast access to these courses.This is a sample of the data that is extracted from the page 70 and itis anticipated that other data are captured such as year offered, classdays, times, professor names, class locations, credit hours, costs,on-line availability, etc. In addition, in some embodiments, school-widedata for the institution is included in the record or pointed to by therecord such as campus maps, room/board information, fees, book store,activities, academic year calendar, transportation, near-by attractions,etc.

Referring to FIG. 7, a typical educational program web page 90 of theprior/current art is shown. This is what a seeker sees when accessing atypical web page 90 having a course description. The page 90, in thisexample, includes a title 91 indicating the educational/trainingprovider and/or department and a sub-title 92 indicating the coursenumber and synopsis. In this example, the page 90 includes oneprerequisite course 94 and several co-requisite courses 96. Also, theclass text book 100 that will be used is includes as well as an overallobjective 102 and detailed objectives 104. The edu bot 20 extracts thedata 91/92/94/96/98/100/102, transforms/normalizes the data91/92/94/96/98/100/102 and stores it in a searchable record within thesearchable educational program database 22. An example of atransformation is to recognize certain acronyms such as “R, L and C” andeither transform them into “Resistors, Inductors and Capacitors” orprovide hot-links to definitions for those who are not familiar with thesubject material.

Referring to FIG. 8, a first typical user interface 110 for retrievingeducational programs is shown. In this, the educational seeker has, forexample, the ability to search for an individual course 114 (e.g.electronic circuits) or to search for a curriculum 116 (e.g. BS inelectronics). This is shown as an example and many other search criteriaand search options are anticipated such as Boolean search capabilities,field search capabilities, etc.

Referring to FIG. 9, a completed typical user interface 120 forretrieving educational programs is shown. In this, the educationalseeker has, for example, entered a search criteria “electronic circuits”to search for an individual course 114 (e.g. electronic circuits). Thisis shown as an example and many other search criteria and search optionsare anticipated such as Boolean search capabilities, field searchcapabilities, etc.

Referring to FIG. 10, a typical response user interface 130 fordisplaying educational programs is shown. The original search criteria“electronic circuits” 132 is shown. In some user interfaces, theeducational seeker is able to enter different criteria into the searchcriteria section 132 and initiate a subsequent search as known in theindustry. The search results are shown as a list with a title 134 andcourse descriptions 136. For example, a class number 100-3-222 138 isoffered at Texas A&M 140 for “Circuit Analysis, network theorems.” Manyother formats and presentations are anticipated. In some embodiments,part or all of each course is or includes a hyper-link and, clicking onthe hyper-link initiates browsing to, for example, a detaileddescription of the course (see FIG. 13) or to the targeteducational/training provider's web site.

Referring to FIG. 11, a completed typical user interface 140 forretrieving educational courses is shown. In this, the educational seekerhas, for example, entered a search criteria “computer science” into the“search for curriculum” 116 to search for a program. This is shown as anexample and many other search criteria and search options areanticipated such as Boolean search capabilities, field searchcapabilities, etc.

Referring to FIG. 12, a typical response user interface 150 fordisplaying educational programs is shown. The original search criteria“computer science” 152 is shown. In some user interfaces, theeducational seeker is able to enter different criteria into the searchcriteria section 152 and initiate a subsequent search as known in theindustry. The search results are shown as a list with a title 154 andprogram descriptions 156. For example, a program number 100-3-200 160 isoffered at Texas A&M 140 leading to a Masters Degree in Computer Science162. Many other formats and presentations are anticipated. In someembodiments, part or all of each program is or includes a hyper-linkand, clicking on the hyper-link initiates browsing to, for example, adetailed description of the course or to the target educational/trainingprovider's web site.

Referring to FIG. 13, a course display user interface 170 for retrievingeducational programs is shown. Once the educational seeker finds acourse of interest as in FIG. 10, the educational seeker selects thecourse by, for example, clicking on the course hyper-link and a coursedisplay user interface 170 is displayed. The course display userinterface 170 includes, for example, the course number, educationalprovider name and brief description 154 as well as a detaileddescription of the course 172 including, for example, pre-requisites,co-requisites, text books, references, objectives, and other informationif available such as professor, location and time of the course, etc.The interface shown in FIG. 13 is an example and any other format,presentation or content are anticipated.

Once the educational seeker has determined that they have some interestin the displayed course summary, the educational seeker has navigationbuttons to, for example, visit the associated educational/trainingprovider's web site 174 or the associated educational/trainingprovider's home department 176 or the actual educational/trainingprovider's web page for that course (not shown).

Referring to FIG. 14, exemplary schema 200 of a database used forretrieving educational programs is shown. This is but an example of aschema for the searchable database 22 and many other variations, ordersand formats are anticipated. A typical schema for records relating toprograms includes a Program Name, Program Type (e.g. what degree orcertification given upon completion of program), Program URL (fornavigation to the educational/training provider's web site), ProgramC.I.P. code (federal education code for program), Program Cost, ProgramDescription, Program Requirements (e.g. needed milestones to enterprogram), Program Course Hours (e.g. credit hours needed to completeprogram) and Program Course List (e.g. a list of courses that make upthe program).

A typical schema for records relating to individual courses includes aCourse Name, Course Number (e.g. internal course identifying number thatdoes not change from year to year), Course Hours (e.g. credit hoursawarded when completing course), Course Description, Course Time (e.g.day, time, period, building, room number, etc), Term (e.g. what semesteror trimester course offered), Campus (e.g. where course is held forexample “main campus”), Course Fees (e.g. cost not included in tuitionsuch as lab fees, travel costs, equipment), Course URL (for navigationto the educational provider's web site), Course ID (e.g. a uniqueidentifier for making all similar courses unique), etc.

Referring to FIG. 15, a schematic view of a system of a secondembodiment is shown. As previously discussed, one or more Edu bots 20periodically visit educational program hosting sites 12/14/16 to extracteducational program offering information, storing the educationalprogram descriptions in the searchable database 22. The educationalprogram hosting sites 12/14/16 are, for example, state universityadmission posting web sites such as the University of Southern Florida(USF) 12 and Rutgers 16; private education web sites such as Devry 14and any known web site containing educational program information. Thisincludes sites for any educational/training providers in any country.

A list of the target educational hosting sites is created by a personsearching the network for such sites. For each particular hosting sitesuch as sites 12/14/16, there is one or more corresponding edu bot 20designed/programmed to find educational program content, parseinformation from the educational program content, normalize theinformation and store the information in the searchable educationalcourse information database 22. For much of the information found in theeducational information, the data is copied directly into a record ofthe searchable educational course information database 22. For example,the schema of the searchable educational course information database 22has a field for prerequisites and the hosting site has a field for entryrequirements, then that field is copied directly into the searchablerecord for that educational program data record. Alternately, if theeducational program has a field for class meeting schedule (e.g. M/T/F8:00 AM) and the searchable educational course information database 22has a field for course meeting days and another field for course meetingtime, then the field is parsed to place “M/T/F” into the field forcourse meeting days and “8:00 AM” in the field for meeting time by adata conversion routine 21.

In the prior embodiment, the educational seekers directly access thesearchable database 22 through a search engine 24 that presents aneducational opportunity search user interface on the educationalseekers' workstation 30 (e.g. personal computer, hand-held device,cellular phone, etc). This generates any of many different types ofsearches and output reports that are anticipated ranging from a simplesearch to a very complex search and detailed report. An example of asimple search is “show me all CNA training classes in Florida.” and anexample of a more complex search is “show me all 4-year schools inFlorida with majors in Biology and provide entrance requirements.” Theformer, for example, results in a list of schools. The later, forexample, results in a list of educational providers along with entryrequirements for each educational provider/curriculum. For example, oneeducational provider requires a SAT score of 1000 for all students, butthen for biology students, freshmen are required to take Chemistry I andII and at least two humanities classes, etc. The generated reportinclude any or all data including the day/time of class meeting,location of classes, lab requirements, credit hours, teacher/professor,cost, cost per credit, pre-requisites, co-requisites, degreerequirements, language of instruction, course/program goals, financialaid, placement programs, certifications of faculty, degree programs,certifications, etc.

In another embodiment, the system also includes job spidering bots 400.Job spidering bots 400 traverse job posting web sites such as privatejob posting sites (e.g. Monster) 410, corporate job posting sites,government job posting sites, educational institution job posting sites,etc. The Job spidering bots 400 extract job postings and store them inthe searchable database 22. In some job spidering bots 400, a dataconverter 402 transforms the job postings into a common format. Forexample, all contact names are stored internally as first name, lastname and the data converter 402 reverses the order of names that are inthe job postings as last name, first name, etc.

Now, having a set of job postings as well as a list of educationalopportunities stored in the searchable database 22, a jobseeker searchesfor job postings and is provided with extended features.

The search engine 24 has search tools to search the job postings in thesearchable database 22. A job seeker enters information regarding thejob they are seeking and the search engine 24 finds all relative jobpostings. In this embodiment, the search engine expands the search torelated job postings for which the job seeker is under-qualified.Finding such job postings for which the job seeker is under-qualified,the search engine then identifies training that is needed that will makethe job seeker qualified for the expanded list of job descriptions. Thesearch engine then performs an auxiliary search of the educationalopportunities in the searchable database to find educationaldescriptions, preferably in the location of the job seeker. By takingadvantage of the educational opportunities, the job seeker then becomesqualified for some or the entire expanded list of job postings.

As an example, a job seeker enters information seeking a position as aNurse and the search engine 24 finds all relative job postings. In thisexample, the search engine expands the search to related job postingsfor which the job seeker is under-qualified such as a nurse manager.Finding several job postings for a nurse manager, which the job seekeris under-qualified, the search engine then identifies managementtraining that is needed to make the job seeker qualified for the nursemanager positions. The search engine performs an auxiliary search of theeducational opportunities to find management coursework required by someor all of the nurse manager job postings, preferably in the location ofthe job seeker. By taking advantage of the educational opportunities,the job seeker will become qualified for some or all of the nursemanager job postings once completed. Such features improve a system thatis designed to find jobs into a system that provides career advancementoptions/suggestions, etc.

Equivalent elements can be substituted for the ones set forth above suchthat they perform in substantially the same manner in substantially thesame way for achieving substantially the same result.

It is believed that the system and method and many of its attendantadvantages will be understood by the foregoing description. It is alsobelieved that it will be apparent that various changes may be made inthe form, construction and arrangement of the components thereof withoutdeparting from the scope and spirit of the invention or withoutsacrificing all of its material advantages. The form herein beforedescribed being merely exemplary and explanatory embodiment thereof. Itis the intention of the following claims to encompass and include suchchanges.

What is claimed is:
 1. A method for creating and updating a consolidateddatabase of educational programs and courses, the method comprising thesteps of: manually identifying a set of educational programs and courseshosting sites; for each site within the set: manually programming andtesting an edu bot specific to the each site by a programmer, the edubot programmed to visit said each site and the edu bot programmed toextract educational program and course information from said each siteand the edu bot programmed to store the educational program and courseinformation in a searchable database; and running the edu bot to visitsaid each site through a network and extracting the educational programand course information into the searchable database; and a plurality ofjob spidering bots, said plurality of job spidering bots traversing jobposting web sites through the network, said plurality of job spideringbots extracting job postings from said job posting web sites, saidplurality of job spidering bots storing said extracted job postings insaid searchable database; periodically running the edu bots to updatethe searchable database; providing a plurality of navigation buttons tosaid each educational programs and courses hosting site within thesearchable database; searching the extracted job postings in saidsearchable database using a search engine, the search engine expandingthe search of the extracted job postings to include job postings forwhich the job seeker is not qualified; and identifying educationalopportunities through an auxiliary search of the extracted educationalprograms in said searchable database for the job seeker for said jobpostings for which the job seeker is not qualified.
 2. The methodaccording to claim 1, further comprising between the step of creatingand the step of running, the step of: testing the edu bot against saideach site to verify that the edu bot correctly extracts the educationalprogram and course information.
 3. The method according to claim 1,wherein the plurality of navigation buttons to said each educationalprograms and courses hosting site further comprising: a visit schoolbutton; and a visit department button.
 4. The method according to claim3, wherein the set of educational programs and courses hosting sitesincludes at least one web site selected from the group consisting of auniversity web site, a college web site and a technical school web site.5. The method according to claim 4, wherein the plurality of navigationbuttons to said each educational programs and courses hosting sitesfurther comprising a course button.
 6. A system for searchingeducational programs in a searchable database, the system comprising: acomputer connected to a network; a storage device operationallyinterfaced to the computer; a searchable database stored within thestorage device; a plurality of edu bots, said plurality of edu botsperiodically visiting educational program hosting sites through thenetwork, said plurality of edu bots extracting educational program andcourse information from the visited educational program hosting sites,said plurality of edu bots storing said extracted educational programand course information in said searchable database; providing aplurality of navigation buttons to said each educational program andcourse hosting site within the searchable database; a plurality of jobspidering bots, said plurality of job spidering bots traversing jobposting web sites through the network, said plurality of job spideringbots extracting job postings from said job posting web sites, saidplurality of job spidering bots storing said extracted job postings insaid searchable database; searching the extracted job postings in saidsearchable database using a search engine, the search engine expandingthe search of the extracted job postings to include job postings forwhich the job seeker is not qualified; and identifying educationalopportunities through an auxiliary search of the extracted educationalprograms in said searchable database for the job seeker for said jobpostings for which the job seeker is not qualified.
 7. The system ofclaim 6, wherein the plurality of navigation buttons to said eacheducational program and course hosting site further comprising: a visitschool button; and a visit department button.
 8. The system of claim 7,wherein the plurality of navigation buttons to said each educationalprogram and course hosting site further comprising a course button.